Open topic with navigation

(continued from Extend Rates)

Modify Rates

Modify Rates is a fairly simple utility which just allows the modification of existing rates. Unlike Duplicate or Extend rates, it performs no insert or adding functions. It can only work with rates that actually exist. The common selection screen is used to select which service options and rates are to be modified.

One use of Modify Rates is when different Buy/Sell currencies are used in the Service Option and the exchange rate factor needs to be updated (see Different Buy/Sell Currencies) This example will demonstrate that process.

Screen Shot 113: Modify Rates - Common Selection Screen

The only fields in this screen to have any values entered are the Based on Date—in this case, rates valid from 01 July 09 to 31 March 10 and Cost Currency = NZD and Sell Currency = USD. The factor between the two rates—including markup—is .75. That is, NZD 100.00 x exchange rate .63 = USD 63.00 plus markup 20% = USD 75.60. Therefore the factor is .75, meaning a negative 25% markup.

Screen Shot 114: Modify Rates – New Cost Settings

Change GB Cost By (Numeric 5,2)

A numeric value can be entered into this field and by selecting one of the two choices from the dropdown, indicate whether the value is a percentage (%) or a currency amount (Flat Rate). This field will adjust the values of the Group Cost column (see Screen Shot 107: Service Option to Rates Duplicated).

Round To Nearest (Dropdown)

Either of the 6 choices from the drop down can be selected. The choices are No rounding, Nearest 0.10, Nearest 0.50, Nearest 1, Nearest 5 or Nearest 10. Rounding is on the basis of up to .5 round down; over .5 round up.

Change FB Cost By (Numeric 5,2)

A numeric value can be entered into this field and by selecting one of the two choices from the dropdown, indicate whether the value is a percentage (%) or a currency amount (Flat Rate). This field will adjust the values of the FIT Cost column (see Screen Shot 107: Service Option to Rates Duplicated).

Round To Nearest (Dropdown)

Either of the 6 choices from the drop down can be selected. The choices are No rounding, Nearest 0.10, Nearest 0.50, Nearest 1, Nearest 5 or Nearest 10. Rounding is on the basis of up to .5 round down; over .5 round up.

Cost Currency (Radio Button

Choices are to Retain Existing Currency or Change To. If change to is checked, the new cost currency can be selected from the drop down.

Change GB Sell By (Numeric 5,2)

This field refers to the Group Sell rate (see Screen Shot 107: Service Option to Rates Duplicated) and can have a numeric value entered. The dropdown following it determine how the value will be applied:

Round To Nearest (Dropdown)

Either of the 6 choices from the drop down can be selected. The choices are No rounding, Nearest 0.10, Nearest 0.50, Nearest 1, Nearest 5 or Nearest 10. Rounding is on the basis of up to .5 round down; over .5 round up.

Change FB Sell By (Numeric 5,2)

This field refers to the FIT sell rate (see Screen Shot 107: Service Option to Rates Duplicated) and can have a numeric value entered. The dropdown following it determine how the value will be applied:

Round To Nearest (Dropdown)

Either of the 6 choices from the drop down can be selected. The choices are No rounding, Nearest 0.10, Nearest 0.50, Nearest 1, Nearest 5 or Nearest 10. Rounding is on the basis of up to .5 round down; over .5 round up.

Sell Currency (Dropdown)

Choices are to Retain Existing Currency or Change To. If change to is checked, the new sell currency can be selected from the drop down.

DB Exchange Rate (Radio Buttons)

When the Cost Currency and/or Sell Currency are changed, and the two currencies are different, this section becomes active. Retain Exchange Rate is the default radio button, but if the database currency calculation rate (here) needs to be changed, click the ‘Change To’ radio button and enter the appropriate rate to use and select either Mult(iply) or Div(ide) as applicable.

Rate Status (Dropdown)

The 6 choices from the dropdown enable the rate status to be retained or updated.

Attach Taxes (Radio Buttons)

This field gives the choice of either retaining any existing taxes that have been attached, have no taxes attached (None) or Selected. When the ‘Selected’ radio button is checked, the list of available taxes becomes available and the applicable tax(s) to be attached can be checked.

Set Apply Markup (Dropdown)

This choice can update the ‘Sell with Markup’ flag. The options are Retain Existing Value, Yes (will set the Sell With Markup Flag ‘On’), or No (will set the ‘Sell With Markup Flag ‘Off’)

Update Pax Breaks (Checkbox)

Checking this box ensures that all rates that are against any existing Pax Breaks are also updated.

Maintain Selections (Checkbox)

Checking this box will hold the Rate Maintenance Selections already entered.

When selections have been completed, click on the ‘Forward’ button to continue. The selections will display and clicking on the Save button will complete the process. To correct any errors, click the ‘Back’ button.

(continued in Copy Rates)

Open topic with navigation